<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> Function Index</title>
<link rel="stylesheet" href="mvl.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets + chunker.py v1.9.2" />
<link rel="start" href="index.html" title="{book-title}" />
<link rel="up" href="" title="" />
<link rel="prev" href="dynindex-command.html" title=" Command Index" />
<link rel="next" href="dynindex-is.html" title=" INFORMATION_SCHEMA Index" />
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center"> Function Index</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="dynindex-command.html">Prev</a> </td>
<th width="60%" align="center"></th>
<td width="20%" align="right"> <a accesskey="n" href="dynindex-is.html">Next</a></td>
</tr>
</table>
<hr>
</div>
<div class="index">

<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="dynindex-function"></a>Function Index</h2>

</div>

</div>

</div>
<p><a name="func-index-top"></a><a class="link" href="dynindex-function.html#func-index-Symbols" title="Symbols">Symbols</a> | <a class="link" href="dynindex-function.html#func-index-A" title="A">A</a> | <a class="link" href="dynindex-function.html#func-index-B" title="B">B</a> | <a class="link" href="dynindex-function.html#func-index-C" title="C">C</a> | <a class="link" href="dynindex-function.html#func-index-D" title="D">D</a> | <a class="link" href="dynindex-function.html#func-index-E" title="E">E</a> | <a class="link" href="dynindex-function.html#func-index-F" title="F">F</a> | <a class="link" href="dynindex-function.html#func-index-G" title="G">G</a> | <a class="link" href="dynindex-function.html#func-index-H" title="H">H</a> | <a class="link" href="dynindex-function.html#func-index-I" title="I">I</a> | <a class="link" href="dynindex-function.html#func-index-J" title="J">J</a> | <a class="link" href="dynindex-function.html#func-index-L" title="L">L</a> | <a class="link" href="dynindex-function.html#func-index-M" title="M">M</a> | <a class="link" href="dynindex-function.html#func-index-N" title="N">N</a> | <a class="link" href="dynindex-function.html#func-index-O" title="O">O</a> | <a class="link" href="dynindex-function.html#func-index-P" title="P">P</a> | <a class="link" href="dynindex-function.html#func-index-Q" title="Q">Q</a> | <a class="link" href="dynindex-function.html#func-index-R" title="R">R</a> | <a class="link" href="dynindex-function.html#func-index-S" title="S">S</a> | <a class="link" href="dynindex-function.html#func-index-T" title="T">T</a> | <a class="link" href="dynindex-function.html#func-index-U" title="U">U</a> | <a class="link" href="dynindex-function.html#func-index-V" title="V">V</a> | <a class="link" href="dynindex-function.html#func-index-W" title="W">W</a> | <a class="link" href="dynindex-function.html#func-index-Y" title="Y">Y</a></p>
<div class="indexdiv">
<a name="func-index-Symbols"></a><h3 class="title">Symbols</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">%</h3>
<dl><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="func-index-A"></a><h3 class="title">A</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ABS()</h3>
<dl><dt><a class="xref" href="extending-mysql.html#adding-functions" title="28.4 Adding New Functions to MySQL">Section 28.4, “Adding New Functions to MySQL”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-function-udf" title="13.7.4.1 CREATE FUNCTION Syntax for User-Defined Functions">Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimizer-statistics" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ACOS()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ADDDATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">addslashes()</h3>
<dl><dt><a class="xref" href="security.html#secure-client-programming" title="6.1.7 Client Programming Security Guidelines">Section 6.1.7, “Client Programming Security Guidelines”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ADDTIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">AES_DECRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="security.html#ssl-libraries" title="6.4.4 OpenSSL Versus wolfSSL">Section 6.4.4, “OpenSSL Versus wolfSSL”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">AES_ENCRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="security.html#ssl-libraries" title="6.4.4 OpenSSL Versus wolfSSL">Section 6.4.4, “OpenSSL Versus wolfSSL”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ANY_VALUE()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#group-by-handling" title="12.19.3 MySQL Handling of GROUP BY">Section 12.19.3, “MySQL Handling of GROUP BY”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASCII()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#help" title="13.8.3 HELP Syntax">Section 13.8.3, “HELP Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASIN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASYMMETRIC_DECRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASYMMETRIC_DERIVE()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASYMMETRIC_ENCRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASYMMETRIC_SIGN()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ASYMMETRIC_VERIFY()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ATAN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ATAN2()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">AVG(</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">AVG()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#date-and-time-type-overview" title="11.1.2 Date and Time Type Overview">Section 11.1.2, “Date and Time Type Overview”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#group-by-optimization" title="8.2.1.14 GROUP BY Optimization">Section 8.2.1.14, “GROUP BY Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#enum" title="11.4.4 The ENUM Type">Section 11.4.4, “The ENUM Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#set" title="11.4.5 The SET Type">Section 11.4.5, “The SET Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="func-index-B"></a><h3 class="title">B</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BENCHMARK()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#derived-tables" title="13.2.11.8 Derived Tables (Subqueries in the FROM Clause)">Section 13.2.11.8, “Derived Tables (Subqueries in the FROM Clause)”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#select-benchmarking" title="8.13.1 Measuring the Speed of Expressions and Functions">Section 8.13.1, “Measuring the Speed of Expressions and Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#optimizing-subqueries" title="13.2.11.10 Optimizing Subqueries">Section 13.2.11.10, “Optimizing Subqueries”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIN()</h3>
<dl><dt><a class="xref" href="language-structure.html#bit-value-literals" title="9.1.5 Bit-Value Literals">Section 9.1.5, “Bit-Value Literals”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIN_TO_UUID()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIT_AND()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIT_COUNT()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIT_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIT_OR()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">BIT_XOR()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="func-index-C"></a><h3 class="title">C</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CAN_ACCESS_COLUMN()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CAN_ACCESS_DATABASE()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CAN_ACCESS_TABLE()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CAN_ACCESS_VIEW()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CAST()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#bit-value-literals" title="9.1.5 Bit-Value Literals">Section 9.1.5, “Bit-Value Literals”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#date-and-time-type-conversion" title="11.3.7 Conversion Between Date and Time Types">Section 11.3.7, “Conversion Between Date and Time Types”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#hexadecimal-literals" title="9.1.4 Hexadecimal Literals">Section 9.1.4, “Hexadecimal Literals”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#differences-from-ansi" title="1.8.2 MySQL Differences from Standard SQL">Section 1.8.2, “MySQL Differences from Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="functions.html#type-conversion" title="12.2 Type Conversion in Expression Evaluation">Section 12.2, “Type Conversion in Expression Evaluation”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#user-variables" title="9.4 User-Defined Variables">Section 9.4, “User-Defined Variables”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#with" title="13.2.13 WITH Syntax (Common Table Expressions)">Section 13.2.13, “WITH Syntax (Common Table Expressions)”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CEIL()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CEILING()</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-linear-hash" title="22.2.4.1 LINEAR HASH Partitioning">Section 22.2.4.1, “LINEAR HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHAR()</h3>
<dl><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHAR_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-unicode-sets" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHARACTER_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHARSET()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COALESCE()</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#join" title="13.2.10.2 JOIN Syntax">Section 13.2.10.2, “JOIN Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#with" title="13.2.13 WITH Syntax (Common Table Expressions)">Section 13.2.13, “WITH Syntax (Common Table Expressions)”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COERCIBILITY()</h3>
<dl><dt><a class="xref" href="charset.html#charset-collation-coercibility" title="10.8.4 Collation Coercibility in Expressions">Section 10.8.4, “Collation Coercibility in Expressions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLLATION()</h3>
<dl><dt><a class="xref" href="error-handling.html#case-sensitivity" title="B.5.4.1 Case Sensitivity in String Searches">Section B.5.4.1, “Case Sensitivity in String Searches”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COMPRESS()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="installing.html#source-configuration-options" title="2.9.4 MySQL Source-Configuration Options">Section 2.9.4, “MySQL Source-Configuration Options”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CONCAT()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-repertoire" title="10.2.1 Character Set Repertoire">Section 10.2.1, “Character Set Repertoire”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collation-coercibility" title="10.8.4 Collation Coercibility in Expressions">Section 10.8.4, “Collation Coercibility in Expressions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-function-udf" title="13.7.4.1 CREATE FUNCTION Syntax for User-Defined Functions">Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-create-view" title="13.7.6.13 SHOW CREATE VIEW Syntax">Section 13.7.6.13, “SHOW CREATE VIEW Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#views-table" title="24.32 The INFORMATION_SCHEMA VIEWS Table">Section 24.32, “The INFORMATION_SCHEMA VIEWS Table”</a></dt><dd></dd><dt><a class="xref" href="functions.html#type-conversion" title="12.2 Type Conversion in Expression Evaluation">Section 12.2, “Type Conversion in Expression Evaluation”</a></dt><dd></dd><dt><a class="xref" href="functions.html#xml-functions" title="12.11 XML Functions">Section 12.11, “XML Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CONCAT_WS()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CONNECTION_ID()</h3>
<dl><dt><a class="xref" href="security.html#audit-log-file-formats" title="6.5.5.4 Audit Log File Formats">Section 6.5.5.4, “Audit Log File Formats”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-generated-columns" title="13.1.18.8 CREATE TABLE and Generated Columns">Section 13.1.18.8, “CREATE TABLE and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#kill" title="13.7.7.4 KILL Syntax">Section 13.7.7.4, “KILL Syntax”</a></dt><dd></dd><dt><a class="xref" href="programs.html#mysql-logging" title="4.5.1.3 mysql Logging">Section 4.5.1.3, “mysql Logging”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-processlist" title="13.7.6.29 SHOW PROCESSLIST Syntax">Section 13.7.6.29, “SHOW PROCESSLIST Syntax”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#threads-table" title="25.11.16.3 The threads Table">Section 25.11.16.3, “The threads Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CONV()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CONVERT()</h3>
<dl><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-introducer" title="10.3.8 Character Set Introducers">Section 10.3.8, “Character Set Introducers”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-literal" title="10.3.6 Character String Literal Character Set and Collation">Section 10.3.6, “Character String Literal Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-cjk" title="A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets">Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean
Character Sets”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CONVERT_TZ()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#lock-tables-restrictions" title="13.3.6.3 Table-Locking Restrictions and Conditions">Section 13.3.6.3, “Table-Locking Restrictions and Conditions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#query-log" title="5.4.3 The General Query Log">Section 5.4.3, “The General Query Log”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#slow-query-log" title="5.4.5 The Slow Query Log">Section 5.4.5, “The Slow Query Log”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">COS()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">COT()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">COUNT()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#counting-rows" title="3.3.4.8 Counting Rows">Section 3.3.4.8, “Counting Rows”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-function-udf" title="13.7.4.1 CREATE FUNCTION Syntax for User-Defined Functions">Section 13.7.4.1, “CREATE FUNCTION Syntax for User-Defined Functions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#group-by-optimization" title="8.2.1.14 GROUP BY Optimization">Section 8.2.1.14, “GROUP BY Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#internal-temporary-tables" title="8.4.4 Internal Temporary Table Use in MySQL">Section 8.4.4, “Internal Temporary Table Use in MySQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#derived-table-optimization" title="8.2.2.3 Optimizing Derived Tables, View References, and Common Table Expressions">Section 8.2.2.3, “Optimizing Derived Tables, View References, and Common Table Expressions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-overview" title="22.1 Overview of Partitioning in MySQL">Section 22.1, “Overview of Partitioning in MySQL”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-updatability" title="23.5.3 Updatable and Insertable Views">Section 23.5.3, “Updatable and Insertable Views”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#where-optimization" title="8.2.1.1 WHERE Clause Optimization">Section 8.2.1.1, “WHERE Clause Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CRC32()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CREATE_ASYMMETRIC_PRIV_KEY()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#enterprise-encryption-usage" title="12.18.2 Enterprise Encryption Usage and Examples">Section 12.18.2, “Enterprise Encryption Usage and Examples”</a></dt><dd></dd><dt><a class="xref" href="programs.html#environment-variables" title="4.9 MySQL Program Environment Variables">Section 4.9, “MySQL Program Environment Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CREATE_ASYMMETRIC_PUB_KEY()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CREATE_DH_PARAMETERS()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#enterprise-encryption-usage" title="12.18.2 Enterprise Encryption Usage and Examples">Section 12.18.2, “Enterprise Encryption Usage and Examples”</a></dt><dd></dd><dt><a class="xref" href="programs.html#environment-variables" title="4.9 MySQL Program Environment Variables">Section 4.9, “MySQL Program Environment Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CREATE_DIGEST()</h3>
<dl><dt><a class="xref" href="functions.html#enterprise-encryption-functions" title="12.18.4 Enterprise Encryption Function Descriptions">Section 12.18.4, “Enterprise Encryption Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CUME_DIST()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURDATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_DATE</h3>
<dl><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#data-type-defaults" title="11.7 Data Type Default Values">Section 11.7, “Data Type Default Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_DATE()</h3>
<dl><dt><a class="xref" href="data-types.html#date-and-time-type-conversion" title="11.3.7 Conversion Between Date and Time Types">Section 11.3.7, “Conversion Between Date and Time Types”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_ROLE()</h3>
<dl><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#roles" title="6.3.4 Using Roles">Section 6.3.4, “Using Roles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_TIME</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_TIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_TIMESTAMP</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-event" title="13.1.12 CREATE EVENT Syntax">Section 13.1.12, “CREATE EVENT Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#data-type-defaults" title="11.7 Data Type Default Values">Section 11.7, “Data Type Default Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_TIMESTAMP()</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_USER</h3>
<dl><dt><a class="xref" href="stored-programs-views.html#stored-programs-security" title="23.6 Access Control for Stored Programs and Views">Section 23.6, “Access Control for Stored Programs and Views”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#alter-user" title="13.7.1.1 ALTER USER Syntax">Section 13.7.1.1, “ALTER USER Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-event" title="13.1.12 CREATE EVENT Syntax">Section 13.1.12, “CREATE EVENT Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-procedure" title="13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax">Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-trigger" title="13.1.20 CREATE TRIGGER Syntax">Section 13.1.20, “CREATE TRIGGER Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-view" title="13.1.21 CREATE VIEW Syntax">Section 13.1.21, “CREATE VIEW Syntax”</a></dt><dd></dd><dt><a class="xref" href="security.html#grant-tables" title="6.2.3 Grant Tables">Section 6.2.3, “Grant Tables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-current-user" title="17.4.1.8 Replication of CURRENT_USER()">Section 17.4.1.8, “Replication of CURRENT_USER()”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-create-user" title="13.7.6.12 SHOW CREATE USER Syntax">Section 13.7.6.12, “SHOW CREATE USER Syntax”</a></dt><dd></dd><dt><a class="xref" href="security.html#account-names" title="6.2.4 Specifying Account Names">Section 6.2.4, “Specifying Account Names”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURRENT_USER()</h3>
<dl><dt><a class="xref" href="security.html#connection-access" title="6.2.6 Access Control, Stage 1: Connection Verification">Section 6.2.6, “Access Control, Stage 1: Connection Verification”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#alter-user" title="13.7.1.1 ALTER USER Syntax">Section 13.7.1.1, “ALTER USER Syntax”</a></dt><dd></dd><dt><a class="xref" href="security.html#audit-log-file-formats" title="6.5.5.4 Audit Log File Formats">Section 6.5.5.4, “Audit Log File Formats”</a></dt><dd></dd><dt><a class="xref" href="security.html#connection-control-installation" title="6.5.2.1 Connection-Control Plugin Installation">Section 6.5.2.1, “Connection-Control Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-event" title="13.1.12 CREATE EVENT Syntax">Section 13.1.12, “CREATE EVENT Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-procedure" title="13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax">Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-generated-columns" title="13.1.18.8 CREATE TABLE and Generated Columns">Section 13.1.18.8, “CREATE TABLE and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-trigger" title="13.1.20 CREATE TRIGGER Syntax">Section 13.1.20, “CREATE TRIGGER Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-view" title="13.1.21 CREATE VIEW Syntax">Section 13.1.21, “CREATE VIEW Syntax”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-authentication-plugins-proxy-users" title="28.2.4.9.4 Implementing Proxy User Support in Authentication Plugins">Section 28.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="security.html#validate-password-options-variables" title="6.5.3.2 Password Validation Options and Variables">Section 6.5.3.2, “Password Validation Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="security.html#proxy-users" title="6.3.11 Proxy Users">Section 6.3.11, “Proxy Users”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-current-user" title="17.4.1.8 Replication of CURRENT_USER()">Section 17.4.1.8, “Replication of CURRENT_USER()”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#set-password" title="13.7.1.10 SET PASSWORD Syntax">Section 13.7.1.10, “SET PASSWORD Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#show-create-user" title="13.7.6.12 SHOW CREATE USER Syntax">Section 13.7.6.12, “SHOW CREATE USER Syntax”</a></dt><dd></dd><dt><a class="xref" href="security.html#account-names" title="6.2.4 Specifying Account Names">Section 6.2.4, “Specifying Account Names”</a></dt><dd></dd><dt><a class="xref" href="security.html#role-names" title="6.2.5 Specifying Role Names">Section 6.2.5, “Specifying Role Names”</a></dt><dd></dd><dt><a class="xref" href="security.html#account-activity-auditing" title="6.3.13 SQL-Based MySQL Account Activity Auditing">Section 6.3.13, “SQL-Based MySQL Account Activity Auditing”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#keyring-service" title="28.3.2 The Keyring Service">Section 28.3.2, “The Keyring Service”</a></dt><dd></dd><dt><a class="xref" href="security.html#keyring-udf-usage" title="6.5.4.8.2 Using General-Purpose Keyring Functions">Section 6.5.4.8.2, “Using General-Purpose Keyring Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-authentication-plugins-server-side" title="28.2.4.9.1 Writing the Server-Side Authentication Plugin">Section 28.2.4.9.1, “Writing the Server-Side Authentication Plugin”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CURTIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#time-zone-support" title="5.1.10 MySQL Server Time Zone Support">Section 5.1.10, “MySQL Server Time Zone Support”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-D"></a><h3 class="title">D</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATABASE()</h3>
<dl><dt><a class="xref" href="tutorial.html#creating-database" title="3.3.1 Creating and Selecting a Database">Section 3.3.1, “Creating and Selecting a Database”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#drop-database" title="13.1.22 DROP DATABASE Syntax">Section 13.1.22, “DROP DATABASE Syntax”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#getting-information" title="3.4 Getting Information About Databases and Tables">Section 3.4, “Getting Information About Databases and Tables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATE_ADD()</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-event" title="13.1.12 CREATE EVENT Syntax">Section 13.1.12, “CREATE EVENT Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#date-and-time-types" title="11.3 Date and Time Types">Section 11.3, “Date and Time Types”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATE_FORMAT()</h3>
<dl><dt><a class="xref" href="connectors-apis.html#c-api-prepared-statement-problems" title="27.7.22 C API Prepared Statement Problems">Section 27.7.22, “C API Prepared Statement Problems”</a></dt><dd></dd><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATE_SUB()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#date-and-time-types" title="11.3 Date and Time Types">Section 11.3, “Date and Time Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DATEDIFF()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DAY()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DAYNAME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DAYOFMONTH()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DAYOFWEEK()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DAYOFYEAR()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DECODE()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DEFAULT()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#alter-table-generated-columns" title="13.1.8.2 ALTER TABLE and Generated Columns">Section 13.1.8.2, “ALTER TABLE and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#data-type-defaults" title="11.7 Data Type Default Values">Section 11.7, “Data Type Default Values”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#insert" title="13.2.6 INSERT Syntax">Section 13.2.6, “INSERT Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#replace" title="13.2.9 REPLACE Syntax">Section 13.2.9, “REPLACE Syntax”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DEGREES()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DENSE_RANK()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DES_DECRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">DES_ENCRYPT()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-E"></a><h3 class="title">E</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ELT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ENCODE()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ENCRYPT()</h3>
<dl><dt><a class="xref" href="introduction.html#contributors" title="1.9.1 Contributors to MySQL">Section 1.9.1, “Contributors to MySQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">EXP()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">EXPORT_SET()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr IN ()</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">expr NOT IN ()</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">EXTRACT()</h3>
<dl><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ExtractValue()</h3>
<dl><dt><a class="xref" href="functions.html#xml-functions" title="12.11 XML Functions">Section 12.11, “XML Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-F"></a><h3 class="title">F</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FIELD()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FIND_IN_SET()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#set" title="11.4.5 The SET Type">Section 11.4.5, “The SET Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FIRST_VALUE()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FLOOR()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#group-by-handling" title="12.19.3 MySQL Handling of GROUP BY">Section 12.19.3, “MySQL Handling of GROUP BY”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimizer-statistics" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FORMAT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FOUND_ROWS()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FROM_BASE64()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FROM_DAYS()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FROM_UNIXTIME()</h3>
<dl><dt><a class="xref" href="introduction.html#contributors" title="1.9.1 Contributors to MySQL">Section 1.9.1, “Contributors to MySQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-timezone" title="17.4.1.33 Replication and Time Zones">Section 17.4.1.33, “Replication and Time Zones”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-G"></a><h3 class="title">G</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GeomCollection()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GeometryCollection()</h3>
<dl><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_DD_COLUMN_PRIVILEGES()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_DD_CREATE_OPTIONS()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_DD_INDEX_SUB_PART_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_FORMAT()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_LOCK</h3>
<dl><dt><a class="xref" href="error-handling.html#error-messages-server" title="B.3 Server Error Codes and Messages">Section B.3, “Server Error Codes and Messages”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GET_LOCK()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#c-api-auto-reconnect" title="27.7.24 C API Automatic Reconnection Control">Section 27.7.24, “C API Automatic Reconnection Control”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-event" title="13.1.12 CREATE EVENT Syntax">Section 13.1.12, “CREATE EVENT Syntax”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#events-overview" title="23.4.1 Event Scheduler Overview">Section 23.4.1, “Event Scheduler Overview”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#general-thread-states" title="8.14.2 General Thread States">Section 8.14.2, “General Thread States”</a></dt><dd></dd><dt><a class="xref" href="group-replication.html#group-replication-limitations" title="18.7.2 Group Replication Limitations">Section 18.7.2, “Group Replication Limitations”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#internal-locking" title="8.11.1 Internal Locking Methods">Section 8.11.1, “Internal Locking Methods”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#kill" title="13.7.7.4 KILL Syntax">Section 13.7.7.4, “KILL Syntax”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#locking-service-monitoring" title="28.3.1.2.3 Locking Service Monitoring">Section 28.3.1.2.3, “Locking Service Monitoring”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-change-user" title="27.7.7.3 mysql_change_user()">Section 27.7.7.3, “mysql_change_user()”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-reset-connection" title="27.7.7.60 mysql_reset_connection()">Section 27.7.7.60, “mysql_reset_connection()”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#lock-tables-restrictions" title="13.3.6.3 Table-Locking Restrictions and Conditions">Section 13.3.6.3, “Table-Locking Restrictions and Conditions”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#locking-service" title="28.3.1 The Locking Service">Section 28.3.1, “The Locking Service”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#metadata-locks-table" title="25.11.12.3 The metadata_locks Table">Section 25.11.12.3, “The metadata_locks Table”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-ps-setup-save" title="26.4.4.14 The ps_setup_save() Procedure">Section 26.4.4.14, “The ps_setup_save() Procedure”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">gethostbyaddr()</h3>
<dl><dt><a class="xref" href="optimization.html#host-cache" title="8.12.4.2 DNS Lookup Optimization and the Host Cache">Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">gethostbyaddr_r()</h3>
<dl><dt><a class="xref" href="optimization.html#host-cache" title="8.12.4.2 DNS Lookup Optimization and the Host Cache">Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">gethostbyname()</h3>
<dl><dt><a class="xref" href="optimization.html#host-cache" title="8.12.4.2 DNS Lookup Optimization and the Host Cache">Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">gethostbyname_r()</h3>
<dl><dt><a class="xref" href="optimization.html#host-cache" title="8.12.4.2 DNS Lookup Optimization and the Host Cache">Section 8.12.4.2, “DNS Lookup Optimization and the Host Cache”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GREATEST()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GROUP_CONCAT()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#internal-temporary-tables" title="8.4.4 Internal Temporary Table Use in MySQL">Section 8.4.4, “Internal Temporary Table Use in MySQL”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GROUPING()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-modifiers" title="12.19.2 GROUP BY Modifiers">Section 12.19.2, “GROUP BY Modifiers”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-usage" title="12.20.2 Window Function Concepts and Syntax">Section 12.20.2, “Window Function Concepts and Syntax”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GTID_SUBSET()</h3>
<dl><dt><a class="xref" href="functions.html#gtid-functions" title="12.17 Functions Used with Global Transaction IDs">Section 12.17, “Functions Used with Global Transaction IDs”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-gtids-concepts" title="17.1.3.1 GTID Format and Storage">Section 17.1.3.1, “GTID Format and Storage”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">GTID_SUBTRACT()</h3>
<dl><dt><a class="xref" href="functions.html#gtid-functions" title="12.17 Functions Used with Global Transaction IDs">Section 12.17, “Functions Used with Global Transaction IDs”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-options-gtids" title="17.1.6.5 Global Transaction ID Options and Variables">Section 17.1.6.5, “Global Transaction ID Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-gtids-concepts" title="17.1.3.1 GTID Format and Storage">Section 17.1.3.1, “GTID Format and Storage”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-H"></a><h3 class="title">H</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">HEX()</h3>
<dl><dt><a class="xref" href="language-structure.html#bit-value-literals" title="9.1.5 Bit-Value Literals">Section 9.1.5, “Bit-Value Literals”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-literal" title="10.3.6 Character String Literal Character Set and Collation">Section 10.3.6, “Character String Literal Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="security.html#keyring-udf-reference" title="6.5.4.8.3 General-Purpose Keyring Function Reference">Section 6.5.4.8.3, “General-Purpose Keyring Function Reference”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#hexadecimal-literals" title="9.1.4 Hexadecimal Literals">Section 9.1.4, “Hexadecimal Literals”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#keyring-udf-usage" title="6.5.4.8.2 Using General-Purpose Keyring Functions">Section 6.5.4.8.2, “Using General-Purpose Keyring Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">HOUR()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-I"></a><h3 class="title">I</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ICU_VERSION()</h3>
<dl><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IF()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#if" title="13.6.5.2 IF Syntax">Section 13.6.5.2, “IF Syntax”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IFNULL()</h3>
<dl><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IN</h3>
<dl><dt><a class="xref" href="functions.html#operator-precedence" title="12.3.1 Operator Precedence">Section 12.3.1, “Operator Precedence”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IN()</h3>
<dl><dt><a class="xref" href="optimization.html#explain-output" title="8.8.2 EXPLAIN Output Format">Section 8.8.2, “EXPLAIN Output Format”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#row-constructor-optimization" title="8.2.1.19 Row Constructor Expression Optimization">Section 8.2.1.19, “Row Constructor Expression Optimization”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="functions.html#type-conversion" title="12.2 Type Conversion in Expression Evaluation">Section 12.2, “Type Conversion in Expression Evaluation”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INET6_ATON()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#ipv6-support" title="5.1.9 IPv6 Support">Section 5.1.9, “IPv6 Support”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INET6_NTOA()</h3>
<dl><dt><a class="xref" href="server-administration.html#ipv6-support" title="5.1.9 IPv6 Support">Section 5.1.9, “IPv6 Support”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INET_ATON()</h3>
<dl><dt><a class="xref" href="server-administration.html#ipv6-support" title="5.1.9 IPv6 Support">Section 5.1.9, “IPv6 Support”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INET_NTOA()</h3>
<dl><dt><a class="xref" href="server-administration.html#ipv6-support" title="5.1.9 IPv6 Support">Section 5.1.9, “IPv6 Support”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INSERT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INSTR()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_AUTO_INCREMENT()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_AVG_ROW_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_CHECK_TIME()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_CHECKSUM()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_DATA_FREE()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_DATA_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_DD_CHAR_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_GET_COMMENT_OR_ERROR()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_GET_VIEW_WARNING_OR_ERROR()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_INDEX_COLUMN_CARDINALITY()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_INDEX_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_KEYS_DISABLED()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_MAX_DATA_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_TABLE_ROWS()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERNAL_UPDATE_TIME()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INTERVAL()</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_FREE_LOCK()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_IPV4()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_IPV4_COMPAT()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_IPV4_MAPPED()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_IPV6()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_USED_LOCK()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_UUID()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">IS_VISIBLE_DD_OBJECT()</h3>
<dl><dt><a class="xref" href="functions.html#internal-functions" title="12.21 Internal Functions">Section 12.21, “Internal Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ISNULL()</h3>
<dl><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-J"></a><h3 class="title">J</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_ARRAY()</h3>
<dl><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_ARRAY_APPEND()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_ARRAY_INSERT()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_ARRAYAGG()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-function-reference" title="12.16.1 JSON Function Reference">Section 12.16.1, “JSON Function Reference”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_CONTAINS()</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_CONTAINS_PATH()</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-path-syntax" title="12.16.8 JSON Path Syntax">Section 12.16.8, “JSON Path Syntax”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_DEPTH()</h3>
<dl><dt><a class="xref" href="functions.html#json-attribute-functions" title="12.16.5 Functions That Return JSON Value Attributes">Section 12.16.5, “Functions That Return JSON Value Attributes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_EXTRACT()</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-secondary-indexes" title="13.1.18.9 Secondary Indexes and Generated Columns">Section 13.1.18.9, “Secondary Indexes and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_INSERT()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_KEYS()</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#json-attribute-functions" title="12.16.5 Functions That Return JSON Value Attributes">Section 12.16.5, “Functions That Return JSON Value Attributes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_MERGE()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_MERGE_PATCH()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_MERGE_PRESERVE()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_OBJECT()</h3>
<dl><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_OBJECTAGG()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-function-reference" title="12.16.1 JSON Function Reference">Section 12.16.1, “JSON Function Reference”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_PRETTY()</h3>
<dl><dt><a class="xref" href="functions.html#json-function-reference" title="12.16.1 JSON Function Reference">Section 12.16.1, “JSON Function Reference”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_QUOTE()</h3>
<dl><dt><a class="xref" href="functions.html#json-creation-functions" title="12.16.2 Functions That Create JSON Values">Section 12.16.2, “Functions That Create JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_REMOVE()</h3>
<dl><dt><a class="xref" href="replication.html#replication-options-binary-log" title="17.1.6.4 Binary Logging Options and Variables">Section 17.1.6.4, “Binary Logging Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_REPLACE()</h3>
<dl><dt><a class="xref" href="replication.html#replication-options-binary-log" title="17.1.6.4 Binary Logging Options and Variables">Section 17.1.6.4, “Binary Logging Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-path-syntax" title="12.16.8 JSON Path Syntax">Section 12.16.8, “JSON Path Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_SEARCH()</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-path-syntax" title="12.16.8 JSON Path Syntax">Section 12.16.8, “JSON Path Syntax”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_SET()</h3>
<dl><dt><a class="xref" href="replication.html#replication-options-binary-log" title="17.1.6.4 Binary Logging Options and Variables">Section 17.1.6.4, “Binary Logging Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-path-syntax" title="12.16.8 JSON Path Syntax">Section 12.16.8, “JSON Path Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_STORAGE_FREE()</h3>
<dl><dt><a class="xref" href="functions.html#json-function-reference" title="12.16.1 JSON Function Reference">Section 12.16.1, “JSON Function Reference”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_STORAGE_SIZE()</h3>
<dl><dt><a class="xref" href="functions.html#json-function-reference" title="12.16.1 JSON Function Reference">Section 12.16.1, “JSON Function Reference”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-utility-functions" title="12.16.7 JSON Utility Functions">Section 12.16.7, “JSON Utility Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_TABLE()</h3>
<dl><dt><a class="xref" href="functions.html#json-table-functions" title="12.16.6 JSON Table Functions">Section 12.16.6, “JSON Table Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_TYPE()</h3>
<dl><dt><a class="xref" href="functions.html#json-attribute-functions" title="12.16.5 Functions That Return JSON Value Attributes">Section 12.16.5, “Functions That Return JSON Value Attributes”</a></dt><dd></dd><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_UNQUOTE(</h3>
<dl><dt><a class="xref" href="functions.html#json-search-functions" title="12.16.3 Functions That Search JSON Values">Section 12.16.3, “Functions That Search JSON Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_UNQUOTE()</h3>
<dl><dt><a class="xref" href="functions.html#json-modification-functions" title="12.16.4 Functions That Modify JSON Values">Section 12.16.4, “Functions That Modify JSON Values”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#generated-column-index-optimizations" title="8.3.11 Optimizer Use of Generated Column Indexes">Section 8.3.11, “Optimizer Use of Generated Column Indexes”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-secondary-indexes" title="13.1.18.9 Secondary Indexes and Generated Columns">Section 13.1.18.9, “Secondary Indexes and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">JSON_VALID()</h3>
<dl><dt><a class="xref" href="functions.html#json-attribute-functions" title="12.16.5 Functions That Return JSON Value Attributes">Section 12.16.5, “Functions That Return JSON Value Attributes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-L"></a><h3 class="title">L</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LAG()</h3>
<dl><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LAST_DAY()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LAST_INSERT_ID()</h3>
<dl><dt><a class="xref" href="connectors-apis.html#c-api-auto-reconnect" title="27.7.24 C API Automatic Reconnection Control">Section 27.7.24, “C API Automatic Reconnection Control”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#getting-unique-id" title="27.7.25.3 How to Get the Unique ID for the Last Inserted Row">Section 27.7.25.3, “How to Get the Unique ID for the Last Inserted Row”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#insert-on-duplicate" title="13.2.6.2 INSERT ... ON DUPLICATE KEY UPDATE Syntax">Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#insert" title="13.2.6 INSERT Syntax">Section 13.2.6, “INSERT Syntax”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-insert-id" title="27.7.7.38 mysql_insert_id()">Section 27.7.7.38, “mysql_insert_id()”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-reset-connection" title="27.7.7.60 mysql_reset_connection()">Section 27.7.7.60, “mysql_reset_connection()”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-stmt-insert-id" title="27.7.11.16 mysql_stmt_insert_id()">Section 27.7.11.16, “mysql_stmt_insert_id()”</a></dt><dd></dd><dt><a class="xref" href="programs.html#mysqlbinlog-hexdump" title="4.6.8.1 mysqlbinlog Hex Dump Format">Section 4.6.8.1, “mysqlbinlog Hex Dump Format”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-auto-increment" title="17.4.1.1 Replication and AUTO_INCREMENT">Section 17.4.1.1, “Replication and AUTO_INCREMENT”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#stored-routines-last-insert-id" title="23.2.4 Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()">Section 23.2.4, “Stored Procedures, Functions, Triggers, and LAST_INSERT_ID()”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#lock-tables-restrictions" title="13.3.6.3 Table-Locking Restrictions and Conditions">Section 13.3.6.3, “Table-Locking Restrictions and Conditions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-problems" title="17.4.4 Troubleshooting Replication">Section 17.4.4, “Troubleshooting Replication”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-updatability" title="23.5.3 Updatable and Insertable Views">Section 23.5.3, “Updatable and Insertable Views”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#example-auto-increment" title="3.6.9 Using AUTO_INCREMENT">Section 3.6.9, “Using AUTO_INCREMENT”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LAST_VALUE()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LCASE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LEAD()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LEAST()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#comparison-operators" title="12.3.2 Comparison Functions and Operators">Section 12.3.2, “Comparison Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LEFT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LENGTH()</h3>
<dl><dt><a class="xref" href="data-types.html#storage-requirements" title="11.8 Data Type Storage Requirements">Section 11.8, “Data Type Storage Requirements”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#gis-data-formats" title="11.5.3 Supported Spatial Data Formats">Section 11.5.3, “Supported Spatial Data Formats”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">Length()</h3>
<dl><dt><a class="xref" href="data-types.html#spatial-types" title="11.5 Spatial Data Types">Section 11.5, “Spatial Data Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LineString()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOAD_FILE()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#enterprise-encryption-usage" title="12.18.2 Enterprise Encryption Usage and Examples">Section 12.18.2, “Enterprise Encryption Usage and Examples”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#load-xml" title="13.2.8 LOAD XML Syntax">Section 13.2.8, “LOAD XML Syntax”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="security.html#privileges-provided" title="6.2.1 Privileges Provided by MySQL">Section 6.2.1, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-options" title="5.1.4 Server Command Options">Section 5.1.4, “Server Command Options”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOCALTIME</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOCALTIME()</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOCALTIMESTAMP</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOCALTIMESTAMP()</h3>
<dl><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOCATE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOG()</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-linear-hash" title="22.2.4.1 LINEAR HASH Partitioning">Section 22.2.4.1, “LINEAR HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOG10()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOG2()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LOWER()</h3>
<dl><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-unicode-sets" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collation-information-schema" title="10.8.7 Using Collation in INFORMATION_SCHEMA Searches">Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LPAD()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">LTRIM()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-M"></a><h3 class="title">M</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MAKE_SET()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MAKEDATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MAKETIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MASTER_POS_WAIT()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#channels-commands-single-channel" title="17.2.3.1 Commands for Operations on a Single Channel">Section 17.2.3.1, “Commands for Operations on a Single Channel”</a></dt><dd></dd><dt><a class="xref" href="replication.html#channels-with-prev-replication" title="17.2.3.2 Compatibility with Previous Replication Statements">Section 17.2.3.2, “Compatibility with Previous Replication Statements”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-replication" title="A.13 MySQL 8.0 FAQ: Replication">Section A.13, “MySQL 8.0 FAQ: Replication”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MATCH</h3>
<dl><dt><a class="xref" href="language-structure.html#expressions" title="9.5 Expression Syntax">Section 9.5, “Expression Syntax”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MATCH ()</h3>
<dl><dt><a class="xref" href="functions.html#fulltext-search" title="12.9 Full-Text Search Functions">Section 12.9, “Full-Text Search Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MATCH()</h3>
<dl><dt><a class="xref" href="functions.html#fulltext-boolean" title="12.9.2 Boolean Full-Text Searches">Section 12.9.2, “Boolean Full-Text Searches”</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-fine-tuning" title="12.9.6 Fine-Tuning MySQL Full-Text Search">Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-restrictions" title="12.9.5 Full-Text Restrictions">Section 12.9.5, “Full-Text Restrictions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-search" title="12.9 Full-Text Search Functions">Section 12.9, “Full-Text Search Functions”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.8.2.4 InnoDB FULLTEXT Indexes">Section 15.8.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-natural-language" title="12.9.1 Natural Language Full-Text Searches">Section 12.9.1, “Natural Language Full-Text Searches”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MAX(</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MAX()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#descending-indexes" title="8.3.13 Descending Indexes">Section 8.3.13, “Descending Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#group-by-optimization" title="8.2.1.14 GROUP BY Optimization">Section 8.2.1.14, “GROUP BY Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#mysql-indexes" title="8.3.1 How MySQL Uses Indexes">Section 8.3.1, “How MySQL Uses Indexes”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#numeric-type-overview" title="11.1.1 Numeric Type Overview">Section 11.1.1, “Numeric Type Overview”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#derived-table-optimization" title="8.2.2.3 Optimizing Derived Tables, View References, and Common Table Expressions">Section 8.2.2.3, “Optimizing Derived Tables, View References, and Common Table Expressions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#optimizing-subqueries" title="13.2.11.10 Optimizing Subqueries">Section 13.2.11.10, “Optimizing Subqueries”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tp-thread-group-state-table" title="24.34.1 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table">Section 24.34.1, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATE Table”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#two-digit-years" title="11.3.8 Two-Digit Years in Dates">Section 11.3.8, “Two-Digit Years in Dates”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-updatability" title="23.5.3 Updatable and Insertable Views">Section 23.5.3, “Updatable and Insertable Views”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-extensions" title="8.3.10 Use of Index Extensions">Section 8.3.10, “Use of Index Extensions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#example-auto-increment" title="3.6.9 Using AUTO_INCREMENT">Section 3.6.9, “Using AUTO_INCREMENT”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#with" title="13.2.13 WITH Syntax (Common Table Expressions)">Section 13.2.13, “WITH Syntax (Common Table Expressions)”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRContains()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#using-spatial-indexes" title="11.5.11 Using Spatial Indexes">Section 11.5.11, “Using Spatial Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRCoveredBy()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRCovers()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRDisjoint()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBREquals()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRIntersects()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBROverlaps()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRTouches()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MBRWithin()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-mbr" title="12.15.9.2 Spatial Relation Functions That Use Minimum Bounding Rectangles">Section 12.15.9.2, “Spatial Relation Functions That Use Minimum Bounding Rectangles”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#using-spatial-indexes" title="11.5.11 Using Spatial Indexes">Section 11.5.11, “Using Spatial Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MD5()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#identifiers" title="9.2 Schema Object Names">Section 9.2, “Schema Object Names”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MICROSECOND()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MID()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MIN(</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MIN()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#c-api-prepared-statement-problems" title="27.7.22 C API Prepared Statement Problems">Section 27.7.22, “C API Prepared Statement Problems”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#descending-indexes" title="8.3.13 Descending Indexes">Section 8.3.13, “Descending Indexes”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#group-by-optimization" title="8.2.1.14 GROUP BY Optimization">Section 8.2.1.14, “GROUP BY Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#mysql-indexes" title="8.3.1 How MySQL Uses Indexes">Section 8.3.1, “How MySQL Uses Indexes”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#bugs" title="B.5.7 Known Issues in MySQL">Section B.5.7, “Known Issues in MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#numeric-type-overview" title="11.1.1 Numeric Type Overview">Section 11.1.1, “Numeric Type Overview”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#derived-table-optimization" title="8.2.2.3 Optimizing Derived Tables, View References, and Common Table Expressions">Section 8.2.2.3, “Optimizing Derived Tables, View References, and Common Table Expressions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#optimizing-subqueries" title="13.2.11.10 Optimizing Subqueries">Section 13.2.11.10, “Optimizing Subqueries”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#two-digit-years" title="11.3.8 Two-Digit Years in Dates">Section 11.3.8, “Two-Digit Years in Dates”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-updatability" title="23.5.3 Updatable and Insertable Views">Section 23.5.3, “Updatable and Insertable Views”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-extensions" title="8.3.10 Use of Index Extensions">Section 8.3.10, “Use of Index Extensions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#where-optimization" title="8.2.1.1 WHERE Clause Optimization">Section 8.2.1.1, “WHERE Clause Optimization”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MINUTE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MOD()</h3>
<dl><dt><a class="xref" href="functions.html#arithmetic-functions" title="12.6.1 Arithmetic Operators">Section 12.6.1, “Arithmetic Operators”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#sql-mode" title="5.1.8 Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MONTH()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MONTHNAME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MultiLineString()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MultiPoint()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">MultiPolygon()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">my_open()</h3>
<dl><dt><a class="xref" href="server-administration.html#server-status-variables" title="5.1.7 Server Status Variables">Section 5.1.7, “Server Status Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-N"></a><h3 class="title">N</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NAME_CONST()</h3>
<dl><dt><a class="xref" href="stored-programs-views.html#stored-programs-logging" title="23.7 Binary Logging of Stored Programs">Section 23.7, “Binary Logging of Stored Programs”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NOT IN()</h3>
<dl><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NOW()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#timestamp-initialization" title="11.3.5 Automatic Initialization and Updating for TIMESTAMP and DATETIME">Section 11.3.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-procedure" title="13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax">Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table-generated-columns" title="13.1.18.8 CREATE TABLE and Generated Columns">Section 13.1.18.8, “CREATE TABLE and Generated Columns”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-table" title="13.1.18 CREATE TABLE Syntax">Section 13.1.18, “CREATE TABLE Syntax”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#data-type-defaults" title="11.7 Data Type Default Values">Section 11.7, “Data Type Default Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#fractional-seconds" title="11.3.6 Fractional Seconds in Time Values">Section 11.3.6, “Fractional Seconds in Time Values”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-general" title="A.1 MySQL 8.0 FAQ: General">Section A.1, “MySQL 8.0 FAQ: General”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#time-zone-support" title="5.1.10 MySQL Server Time Zone Support">Section 5.1.10, “MySQL Server Time Zone Support”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-timezone" title="17.4.1.33 Replication and Time Zones">Section 17.4.1.33, “Replication and Time Zones”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-options" title="5.1.4 Server Command Options">Section 5.1.4, “Server Command Options”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-metrics" title="26.4.3.21 The metrics View">Section 26.4.3.21, “The metrics View”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-statement-performance-analyzer" title="26.4.4.25 The statement_performance_analyzer() Procedure">Section 26.4.4.25, “The statement_performance_analyzer() Procedure”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#year" title="11.3.3 The YEAR Type">Section 11.3.3, “The YEAR Type”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#time-zone-leap-seconds" title="5.1.10.2 Time Zone Leap Second Support">Section 5.1.10.2, “Time Zone Leap Second Support”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NTH_VALUE()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NTILE()</h3>
<dl><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NULLIF()</h3>
<dl><dt><a class="xref" href="functions.html#control-flow-functions" title="12.4 Control Flow Functions">Section 12.4, “Control Flow Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-O"></a><h3 class="title">O</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">OCT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">OCTET_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ORD()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-P"></a><h3 class="title">P</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PASSWORD()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PERCENT_RANK()</h3>
<dl><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PERIOD_ADD()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PERIOD_DIFF()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PI()</h3>
<dl><dt><a class="xref" href="language-structure.html#function-resolution" title="9.2.4 Function Name Parsing and Resolution">Section 9.2.4, “Function Name Parsing and Resolution”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">Point()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#gis-data-formats" title="11.5.3 Supported Spatial Data Formats">Section 11.5.3, “Supported Spatial Data Formats”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">Polygon()</h3>
<dl><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">POSITION()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">POW()</h3>
<dl><dt><a class="xref" href="optimization.html#function-optimization" title="8.2.1.17 Function Call Optimization">Section 8.2.1.17, “Function Call Optimization”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-hash" title="22.2.4 HASH Partitioning">Section 22.2.4, “HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">POWER()</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-linear-hash" title="22.2.4.1 LINEAR HASH Partitioning">Section 22.2.4.1, “LINEAR HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">pthread_mutex()</h3>
<dl><dt><a class="xref" href="introduction.html#contributors" title="1.9.1 Contributors to MySQL">Section 1.9.1, “Contributors to MySQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-Q"></a><h3 class="title">Q</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">QUARTER()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">QUOTE()</h3>
<dl><dt><a class="xref" href="connectors-apis.html#mysql-real-escape-string" title="27.7.7.55 mysql_real_escape_string()">Section 27.7.7.55, “mysql_real_escape_string()”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-real-escape-string-quote" title="27.7.7.56 mysql_real_escape_string_quote()">Section 27.7.7.56, “mysql_real_escape_string_quote()”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="language-structure.html#string-literals" title="9.1.1 String Literals">Section 9.1.1, “String Literals”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-R"></a><h3 class="title">R</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RADIANS()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RAND()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#create-procedure" title="13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax">Section 13.1.15, “CREATE PROCEDURE and CREATE FUNCTION Syntax”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#function-optimization" title="8.2.1.17 Function Call Optimization">Section 8.2.1.17, “Function Call Optimization”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="programs.html#mysqlbinlog-hexdump" title="4.6.8.1 mysqlbinlog Hex Dump Format">Section 4.6.8.1, “mysqlbinlog Hex Dump Format”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RANDOM_BYTES()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RANK()</h3>
<dl><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REGEXP_INSTR()</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REGEXP_LIKE()</h3>
<dl><dt><a class="xref" href="tutorial.html#pattern-matching" title="3.3.4.7 Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dd></dd><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REGEXP_REPLACE()</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REGEXP_SUBSTR()</h3>
<dl><dt><a class="xref" href="functions.html#regexp" title="12.5.2 Regular Expressions">Section 12.5.2, “Regular Expressions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RELEASE_ALL_LOCKS()</h3>
<dl><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RELEASE_LOCK()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#do" title="13.2.3 DO Syntax">Section 13.2.3, “DO Syntax”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#internal-locking" title="8.11.1 Internal Locking Methods">Section 8.11.1, “Internal Locking Methods”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#lock-tables-restrictions" title="13.3.6.3 Table-Locking Restrictions and Conditions">Section 13.3.6.3, “Table-Locking Restrictions and Conditions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REPEAT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REPLACE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">REVERSE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RIGHT()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ROLES_GRAPHML()</h3>
<dl><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#privileges-provided" title="6.2.1 Privileges Provided by MySQL">Section 6.2.1, “Privileges Provided by MySQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ROUND()</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.14.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.14.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#precision-math" title="12.23 Precision Math">Section 12.23, “Precision Math”</a></dt><dd></dd><dt><a class="xref" href="functions.html#precision-math-examples" title="12.23.5 Precision Math Examples">Section 12.23.5, “Precision Math Examples”</a></dt><dd></dd><dt><a class="xref" href="functions.html#precision-math-rounding" title="12.23.4 Rounding Behavior">Section 12.23.4, “Rounding Behavior”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ROW_COUNT()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#call" title="13.2.1 CALL Syntax">Section 13.2.1, “CALL Syntax”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#delete" title="13.2.2 DELETE Syntax">Section 13.2.2, “DELETE Syntax”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#diagnostics-area-information-items" title="13.6.7.7.2 Diagnostics Area Information Items">Section 13.6.7.7.2, “Diagnostics Area Information Items”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#insert" title="13.2.6 INSERT Syntax">Section 13.2.6, “INSERT Syntax”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="connectors-apis.html#mysql-affected-rows" title="27.7.7.1 mysql_affected_rows()">Section 27.7.7.1, “mysql_affected_rows()”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ROW_NUMBER()</h3>
<dl><dt><a class="xref" href="functions.html#window-functions-usage" title="12.20.2 Window Function Concepts and Syntax">Section 12.20.2, “Window Function Concepts and Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-function-descriptions" title="12.20.1 Window Function Descriptions">Section 12.20.1, “Window Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RPAD()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">RTRIM()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-S"></a><h3 class="title">S</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SCHEMA()</h3>
<dl><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SEC_TO_TIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SECOND()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SESSION_USER()</h3>
<dl><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">setrlimit()</h3>
<dl><dt><a class="xref" href="server-administration.html#server-options" title="5.1.4 Server Command Options">Section 5.1.4, “Server Command Options”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SHA()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SHA1()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SHA2()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#security-guidelines" title="6.1.1 Security Guidelines">Section 6.1.1, “Security Guidelines”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SIGN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SIN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#udf-arguments" title="28.4.2.3 UDF Argument Processing">Section 28.4.2.3, “UDF Argument Processing”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SLEEP()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#general-thread-states" title="8.14.2 General Thread States">Section 8.14.2, “General Thread States”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tp-thread-group-stats-table" title="24.34.2 The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table">Section 24.34.2, “The INFORMATION_SCHEMA TP_THREAD_GROUP_STATS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SOUNDEX()</h3>
<dl><dt><a class="xref" href="extending-mysql.html#adding-functions" title="28.4 Adding New Functions to MySQL">Section 28.4, “Adding New Functions to MySQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SPACE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SQRT()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Area()</h3>
<dl><dt><a class="xref" href="functions.html#gis-property-functions" title="12.15.7 Geometry Property Functions">Section 12.15.7, “Geometry Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_AsBinary()</h3>
<dl><dt><a class="xref" href="data-types.html#fetching-spatial-data" title="11.5.8 Fetching Spatial Data">Section 11.5.8, “Fetching Spatial Data”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_AsGeoJSON()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geojson-functions" title="12.15.11 Spatial GeoJSON Functions">Section 12.15.11, “Spatial GeoJSON Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_AsText()</h3>
<dl><dt><a class="xref" href="data-types.html#fetching-spatial-data" title="11.5.8 Fetching Spatial Data">Section 11.5.8, “Fetching Spatial Data”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_AsWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_AsWKT()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Buffer()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Buffer_Strategy()</h3>
<dl><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Centroid()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Contains()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_ConvexHull()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Crosses()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Difference()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Dimension()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Disjoint()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Distance()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Distance_Sphere()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_EndPoint()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Envelope()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Equals()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_ExteriorRing()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeoHash()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geohash-functions" title="12.15.10 Spatial Geohash Functions">Section 12.15.10, “Spatial Geohash Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomCollFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomCollFromTxt()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomCollFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryCollectionFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryCollectionFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryN()</h3>
<dl><dt><a class="xref" href="functions.html#gis-geometrycollection-property-functions" title="12.15.7.5 GeometryCollection Property Functions">Section 12.15.7.5, “GeometryCollection Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeometryType()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomFromGeoJSON()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geojson-functions" title="12.15.11 Spatial GeoJSON Functions">Section 12.15.11, “Spatial GeoJSON Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#json" title="11.6 The JSON Data Type">Section 11.6, “The JSON Data Type”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gis-mysql-specific-functions" title="12.15.5 MySQL-Specific Functions That Create Geometry Values">Section 12.15.5, “MySQL-Specific Functions That Create Geometry Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#populating-spatial-columns" title="11.5.7 Populating Spatial Columns">Section 11.5.7, “Populating Spatial Columns”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#gis-data-formats" title="11.5.3 Supported Spatial Data Formats">Section 11.5.3, “Supported Spatial Data Formats”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_GeomFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_InteriorRingN()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Intersection()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Intersects()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_IsClosed()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_IsEmpty()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_IsSimple()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_IsValid()</h3>
<dl><dt><a class="xref" href="data-types.html#geometry-well-formedness-validity" title="11.5.4 Geometry Well-Formedness and Validity">Section 11.5.4, “Geometry Well-Formedness and Validity”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LatFromGeoHash()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geohash-functions" title="12.15.10 Spatial Geohash Functions">Section 12.15.10, “Spatial Geohash Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Latitude()</h3>
<dl><dt><a class="xref" href="functions.html#gis-point-property-functions" title="12.15.7.2 Point Property Functions">Section 12.15.7.2, “Point Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Length()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#spatial-types" title="11.5 Spatial Data Types">Section 11.5, “Spatial Data Types”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LineFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LineFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LineStringFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LineStringFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_LongFromGeoHash()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geohash-functions" title="12.15.10 Spatial Geohash Functions">Section 12.15.10, “Spatial Geohash Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Longitude()</h3>
<dl><dt><a class="xref" href="functions.html#gis-point-property-functions" title="12.15.7.2 Point Property Functions">Section 12.15.7.2, “Point Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MakeEnvelope()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MLineFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MLineFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MPointFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#gis-data-formats" title="11.5.3 Supported Spatial Data Formats">Section 11.5.3, “Supported Spatial Data Formats”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MPointFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MPolyFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MPolyFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiLineStringFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiLineStringFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiPointFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiPointFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiPolygonFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_MultiPolygonFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_NumGeometries()</h3>
<dl><dt><a class="xref" href="functions.html#gis-geometrycollection-property-functions" title="12.15.7.5 GeometryCollection Property Functions">Section 12.15.7.5, “GeometryCollection Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_NumInteriorRing()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_NumInteriorRings()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_NuminteriorRings()</h3>
<dl><dt><a class="xref" href="functions.html#gis-polygon-property-functions" title="12.15.7.4 Polygon and MultiPolygon Property Functions">Section 12.15.7.4, “Polygon and MultiPolygon Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_NumPoints()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Overlaps()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PointFromGeoHash()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-geohash-functions" title="12.15.10 Spatial Geohash Functions">Section 12.15.10, “Spatial Geohash Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PointFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PointFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PointN()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PolyFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PolyFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PolygonFromText()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkt-functions" title="12.15.3 Functions That Create Geometry Values from WKT Values">Section 12.15.3, “Functions That Create Geometry Values from WKT Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_PolygonFromWKB()</h3>
<dl><dt><a class="xref" href="functions.html#gis-wkb-functions" title="12.15.4 Functions That Create Geometry Values from WKB Values">Section 12.15.4, “Functions That Create Geometry Values from WKB Values”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Simplify()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_SRID()</h3>
<dl><dt><a class="xref" href="functions.html#gis-general-property-functions" title="12.15.7.1 General Geometry Property Functions">Section 12.15.7.1, “General Geometry Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_StartPoint()</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.15.7.3 LineString and MultiLineString Property Functions">Section 12.15.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_SwapXY()</h3>
<dl><dt><a class="xref" href="functions.html#gis-format-conversion-functions" title="12.15.6 Geometry Format Conversion Functions">Section 12.15.6, “Geometry Format Conversion Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_SymDifference()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Touches()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Union()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-operator-functions" title="12.15.8 Spatial Operator Functions">Section 12.15.8, “Spatial Operator Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Validate()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-convenience-functions" title="12.15.12 Spatial Convenience Functions">Section 12.15.12, “Spatial Convenience Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Within()</h3>
<dl><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.15.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.15.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_X()</h3>
<dl><dt><a class="xref" href="functions.html#gis-point-property-functions" title="12.15.7.2 Point Property Functions">Section 12.15.7.2, “Point Property Functions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#gis-data-formats" title="11.5.3 Supported Spatial Data Formats">Section 11.5.3, “Supported Spatial Data Formats”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ST_Y()</h3>
<dl><dt><a class="xref" href="functions.html#gis-point-property-functions" title="12.15.7.2 Point Property Functions">Section 12.15.7.2, “Point Property Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STATEMENT_DIGEST()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-statement-digests" title="25.9 Performance Schema Statement Digests and Sampling">Section 25.9, “Performance Schema Statement Digests and Sampling”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STATEMENT_DIGEST_TEXT()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-statement-digests" title="25.9 Performance Schema Statement Digests and Sampling">Section 25.9, “Performance Schema Statement Digests and Sampling”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STD()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STDDEV()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STDDEV_POP()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STDDEV_SAMP()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STR_TO_DATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#locale-support" title="10.15 MySQL Server Locale Support">Section 10.15, “MySQL Server Locale Support”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">STRCMP()</h3>
<dl><dt><a class="xref" href="error-handling.html#using-date" title="B.5.4.2 Problems Using DATE Columns">Section B.5.4.2, “Problems Using DATE Columns”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-comparison-functions" title="12.5.1 String Comparison Functions">Section 12.5.1, “String Comparison Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUBDATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUBSTR()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUBSTRING()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUBSTRING_INDEX()</h3>
<dl><dt><a class="xref" href="security.html#account-activity-auditing" title="6.3.13 SQL-Based MySQL Account Activity Auditing">Section 6.3.13, “SQL-Based MySQL Account Activity Auditing”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUBTIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUM(</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SUM()</h3>
<dl><dt><a class="xref" href="extending-mysql.html#adding-udf" title="28.4.2 Adding a New User-Defined Function">Section 28.4.2, “Adding a New User-Defined Function”</a></dt><dd></dd><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#date-and-time-type-overview" title="11.1.2 Date and Time Type Overview">Section 11.1.2, “Date and Time Type Overview”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#group-by-optimization" title="8.2.1.14 GROUP BY Optimization">Section 8.2.1.14, “GROUP BY Optimization”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#derived-table-optimization" title="8.2.2.3 Optimizing Derived Tables, View References, and Common Table Expressions">Section 8.2.2.3, “Optimizing Derived Tables, View References, and Common Table Expressions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-overview" title="22.1 Overview of Partitioning in MySQL">Section 22.1, “Overview of Partitioning in MySQL”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#problems-with-null" title="B.5.4.3 Problems with NULL Values">Section B.5.4.3, “Problems with NULL Values”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#enum" title="11.4.4 The ENUM Type">Section 11.4.4, “The ENUM Type”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#features" title="1.3.2 The Main Features of MySQL">Section 1.3.2, “The Main Features of MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#set" title="11.4.5 The SET Type">Section 11.4.5, “The SET Type”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#view-updatability" title="23.5.3 Updatable and Insertable Views">Section 23.5.3, “Updatable and Insertable Views”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-usage" title="12.20.2 Window Function Concepts and Syntax">Section 12.20.2, “Window Function Concepts and Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#window-functions-frames" title="12.20.3 Window Function Frame Specification">Section 12.20.3, “Window Function Frame Specification”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SYSDATE()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-options" title="5.1.4 Server Command Options">Section 5.1.4, “Server Command Options”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">SYSTEM_USER()</h3>
<dl><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-T"></a><h3 class="title">T</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TAN()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIME_FORMAT()</h3>
<dl><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIME_TO_SEC()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIMEDIFF()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIMESTAMP()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIMESTAMPADD()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TIMESTAMPDIFF()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TO_BASE64()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TO_DAYS()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-hash" title="22.2.4 HASH Partitioning">Section 22.2.4, “HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-pruning" title="22.4 Partition Pruning">Section 22.4, “Partition Pruning”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TO_SECONDS()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-pruning" title="22.4 Partition Pruning">Section 22.4, “Partition Pruning”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TRIM()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-conversion" title="10.7 Column Character Set Conversion">Section 10.7, “Column Character Set Conversion”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">TRUNCATE()</h3>
<dl><dt><a class="xref" href="functions.html#mathematical-functions" title="12.6.2 Mathematical Functions">Section 12.6.2, “Mathematical Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-U"></a><h3 class="title">U</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UCASE()</h3>
<dl><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UNCOMPRESS()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="installing.html#source-configuration-options" title="2.9.4 MySQL Source-Configuration Options">Section 2.9.4, “MySQL Source-Configuration Options”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UNCOMPRESSED_LENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UNHEX()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UNIX_TIMESTAMP()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-range" title="22.2.1 RANGE Partitioning">Section 22.2.1, “RANGE Partitioning”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-metrics" title="26.4.3.21 The metrics View">Section 26.4.3.21, “The metrics View”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#timezone-problems" title="B.5.3.7 Time Zone Problems">Section B.5.3.7, “Time Zone Problems”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UpdateXML()</h3>
<dl><dt><a class="xref" href="functions.html#xml-functions" title="12.11 XML Functions">Section 12.11, “XML Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UPPER()</h3>
<dl><dt><a class="xref" href="functions.html#cast-functions" title="12.10 Cast Functions and Operators">Section 12.10, “Cast Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions-charset" title="12.5.3 Character Set and Collation of Function Results">Section 12.5.3, “Character Set and Collation of Function Results”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-repertoire" title="10.2.1 Character Set Repertoire">Section 10.2.1, “Character Set Repertoire”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-unicode-sets" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collation-information-schema" title="10.8.7 Using Collation in INFORMATION_SCHEMA Searches">Section 10.8.7, “Using Collation in INFORMATION_SCHEMA Searches”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">USER()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="sql-syntax.html#alter-user" title="13.7.1.1 ALTER USER Syntax">Section 13.7.1.1, “ALTER USER Syntax”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collation-coercibility" title="10.8.4 Collation Coercibility in Expressions">Section 10.8.4, “Collation Coercibility in Expressions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-authentication-plugins-proxy-users" title="28.2.4.9.4 Implementing Proxy User Support in Authentication Plugins">Section 28.2.4.9.4, “Implementing Proxy User Support in Authentication Plugins”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="security.html#validate-password-options-variables" title="6.5.3.2 Password Validation Options and Variables">Section 6.5.3.2, “Password Validation Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="security.html#proxy-users" title="6.3.11 Proxy Users">Section 6.3.11, “Proxy Users”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#account-activity-auditing" title="6.3.13 SQL-Based MySQL Account Activity Auditing">Section 6.3.13, “SQL-Based MySQL Account Activity Auditing”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-authentication-plugins-server-side" title="28.2.4.9.1 Writing the Server-Side Authentication Plugin">Section 28.2.4.9.1, “Writing the Server-Side Authentication Plugin”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_DATE</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_DATE()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_TIME</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_TIME()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_TIMESTAMP</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UTC_TIMESTAMP()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#time-zone-support" title="5.1.10 MySQL Server Time Zone Support">Section 5.1.10, “MySQL Server Time Zone Support”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UUID()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="stored-programs-views.html#stored-programs-logging" title="23.7 Binary Logging of Stored Programs">Section 23.7, “Binary Logging of Stored Programs”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-options-binary-log" title="17.1.6.4 Binary Logging Options and Variables">Section 17.1.6.4, “Binary Logging Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#function-optimization" title="8.2.1.17 Function Call Optimization">Section 8.2.1.17, “Function Call Optimization”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#binary-log-mixed" title="5.4.4.3 Mixed Binary Logging Format">Section 5.4.4.3, “Mixed Binary Logging Format”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UUID_SHORT()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-rbr-safe-unsafe" title="17.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging">Section 17.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">UUID_TO_BIN()</h3>
<dl><dt><a class="xref" href="functions.html#bit-functions" title="12.12 Bit Functions and Operators">Section 12.12, “Bit Functions and Operators”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="func-index-V"></a><h3 class="title">V</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VALIDATE_PASSWORD_STRENGTH()</h3>
<dl><dt><a class="xref" href="functions.html#encryption-functions" title="12.13 Encryption and Compression Functions">Section 12.13, “Encryption and Compression Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#validate-password-options-variables" title="6.5.3.2 Password Validation Options and Variables">Section 6.5.3.2, “Password Validation Options and Variables”</a></dt><dd></dd><dt><a class="xref" href="security.html#validate-password" title="6.5.3 The Password Validation Component">Section 6.5.3, “The Password Validation Component”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#plugin-types" title="28.2.1 Types of Plugins">Section 28.2.1, “Types of Plugins”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VALUES()</h3>
<dl><dt><a class="xref" href="sql-syntax.html#insert-on-duplicate" title="13.2.6.2 INSERT ... ON DUPLICATE KEY UPDATE Syntax">Section 13.2.6.2, “INSERT ... ON DUPLICATE KEY UPDATE Syntax”</a></dt><dd></dd><dt><a class="xref" href="functions.html#miscellaneous-functions" title="12.22 Miscellaneous Functions">Section 12.22, “Miscellaneous Functions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VAR_POP()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VAR_SAMP()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#window-function-optimization" title="8.2.1.18 Window Function Optimization">Section 8.2.1.18, “Window Function Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VARIANCE()</h3>
<dl><dt><a class="xref" href="functions.html#group-by-functions" title="12.19.1 Aggregate (GROUP BY) Function Descriptions">Section 12.19.1, “Aggregate (GROUP BY) Function Descriptions”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">VERSION()</h3>
<dl><dt><a class="xref" href="replication.html#replication-sbr-rbr" title="17.2.1.1 Advantages and Disadvantages of Statement-Based and Row-Based Replication">Section 17.2.1.1, “Advantages and Disadvantages of Statement-Based and Row-Based
Replication”</a></dt><dd></dd><dt><a class="xref" href="security.html#audit-log-file-formats" title="6.5.5.4 Audit Log File Formats">Section 6.5.5.4, “Audit Log File Formats”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#case-sensitivity" title="B.5.4.1 Case Sensitivity in String Searches">Section B.5.4.1, “Case Sensitivity in String Searches”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-collation-coercibility" title="10.8.4 Collation Coercibility in Expressions">Section 10.8.4, “Collation Coercibility in Expressions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.14 Information Functions">Section 12.14, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-functions" title="17.4.1.14 Replication and System Functions">Section 17.4.1.14, “Replication and System Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-metadata" title="10.2.2 UTF-8 for Metadata">Section 10.2.2, “UTF-8 for Metadata”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="func-index-W"></a><h3 class="title">W</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WAIT_FOR_EXECUTED_GTID_SET()</h3>
<dl><dt><a class="xref" href="replication.html#channels-with-prev-replication" title="17.2.3.2 Compatibility with Previous Replication Statements">Section 17.2.3.2, “Compatibility with Previous Replication Statements”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gtid-functions" title="12.17 Functions Used with Global Transaction IDs">Section 12.17, “Functions Used with Global Transaction IDs”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-mode-change-online-concepts" title="17.1.5.1 Replication Mode Concepts">Section 17.1.5.1, “Replication Mode Concepts”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WAIT_UNTIL_SQL_THREAD_AFTER_GTIDS()</h3>
<dl><dt><a class="xref" href="replication.html#channels-commands-single-channel" title="17.2.3.1 Commands for Operations on a Single Channel">Section 17.2.3.1, “Commands for Operations on a Single Channel”</a></dt><dd></dd><dt><a class="xref" href="replication.html#channels-with-prev-replication" title="17.2.3.2 Compatibility with Previous Replication Statements">Section 17.2.3.2, “Compatibility with Previous Replication Statements”</a></dt><dd></dd><dt><a class="xref" href="functions.html#gtid-functions" title="12.17 Functions Used with Global Transaction IDs">Section 12.17, “Functions Used with Global Transaction IDs”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WEEK()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.5 Server System Variables">Section 5.1.5, “Server System Variables”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WEEKDAY()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#extensions-to-ansi" title="1.8.1 MySQL Extensions to Standard SQL">Section 1.8.1, “MySQL Extensions to Standard SQL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WEEKOFYEAR()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">WEIGHT_STRING()</h3>
<dl><dt><a class="xref" href="charset.html#adding-collation" title="10.13 Adding a Collation to a Character Set">Section 10.13, “Adding a Collation to a Character Set”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#case-sensitivity" title="B.5.4.1 Case Sensitivity in String Searches">Section B.5.4.1, “Case Sensitivity in String Searches”</a></dt><dd></dd><dt><a class="xref" href="functions.html#string-functions" title="12.5 String Functions">Section 12.5, “String Functions”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-unicode-sets" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="func-index-Y"></a><h3 class="title">Y</h3>
<p>[<a class="link" href="dynindex-function.html#func-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">YEAR()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="tutorial.html#date-calculations" title="3.3.4.5 Date Calculations">Section 3.3.4.5, “Date Calculations”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-hash" title="22.2.4 HASH Partitioning">Section 22.2.4, “HASH Partitioning”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-handling-nulls" title="22.2.7 How MySQL Partitioning Handles NULL">Section 22.2.7, “How MySQL Partitioning Handles NULL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-management-range-list" title="22.3.1 Management of RANGE and LIST Partitions">Section 22.3.1, “Management of RANGE and LIST Partitions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-pruning" title="22.4 Partition Pruning">Section 22.4, “Partition Pruning”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-types" title="22.2 Partitioning Types">Section 22.2, “Partitioning Types”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-range" title="22.2.1 RANGE Partitioning">Section 22.2.1, “RANGE Partitioning”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">YEARWEEK()</h3>
<dl><dt><a class="xref" href="functions.html#date-and-time-functions" title="12.7 Date and Time Functions">Section 12.7, “Date and Time Functions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-limitations-functions" title="22.6.3 Partitioning Limitations Relating to Functions">Section 22.6.3, “Partitioning Limitations Relating to Functions”</a></dt><dd></dd></dl>
</div>

</div>

<div class="copyright-footer">

</div>
<div class="navfooter">
<hr>
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="dynindex-command.html">Prev</a></td>
<td width="20%" align="center"><a accesskey="u" href="">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="dynindex-is.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top"> Command Index</td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top"> INFORMATION_SCHEMA Index</td>
</tr>
</table>
</div>
</body>
</html>
